package com.lovo.invoicing.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lovo.invoicing.bean.SaleInfoBean;
import com.lovo.invoicing.bean.vo.SaleGoodsBean;
import com.lovo.invoicing.bean.vo.SaleInfoSaleBean;
import com.lovo.invoicing.bean.vo.SaleMonthBean;
import com.lovo.invoicing.bean.vo.SaleTypeBean;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Mapper
public interface SaleInfoMapper extends BaseMapper<SaleInfoBean> {
   List<SaleInfoSaleBean> selectBySaleInfoId(int saleInfoId);

   List<SaleTypeBean> selectTypeTotal(@Param("startDate") String startDate, @Param("endDate") String endDate);

   List<SaleGoodsBean> selectNameTotal(@Param("startDate") String startDate, @Param("endDate") String endDate);


   List<String> selectAllSaleYear();

   List<Double> selectComputerPrices(String saleYear);

   List<Double> selectSecurityPrices(String saleYear);
   List<Double> selectWorkPrices(String saleYear);

   List<String> selectMonthsByYear(String saleYear);
}
